UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3egKphXKA52sJWU3dfQF7YX36CFgxlrRczSdHPjjKU='
WHERE
key_id = '247487cdd97df6dbbb5d0079d277b61c9edbbb2e6603ab784a75d45996ea28f8'
AND (
token = 'D3egKphXKA52sJWU3dfQF7YX36CFgxlrRczSdHPjjKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)