UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NNY6OfX9Blfp3C0Zes4qNifpMMr7N2MF1Q3wSHgfhPA='
WHERE
key_id = '7e78da35968c1071a39e75d2c8823af552c032cbcfa81345d0bf49d5a485848f'
AND (
token = 'NNY6OfX9Blfp3C0Zes4qNifpMMr7N2MF1Q3wSHgfhPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)