UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NMq1RJFpCcu+7mwnccHrPX+sJq2Lup+U0bbcmqKaAgk='
WHERE
key_id = 'df0efd4a4b29e21e8a471e2105cb576c33e039b358a4c502237b30c54dd72ec5'
AND (
token = 'NMq1RJFpCcu+7mwnccHrPX+sJq2Lup+U0bbcmqKaAgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)