UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ULTCkDL1HeySH7UPQ83u1991i0TUp9OjXBhdTuu7wbw='
WHERE
key_id = '3500c63b0936c408321188bf0c35157a08ebe42ea22ddb350ec5dc8e52c21a5a'
AND (
token = 'ULTCkDL1HeySH7UPQ83u1991i0TUp9OjXBhdTuu7wbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)