UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXgN5YxJlrD34whfPg+Jw0mRcysV+HwI/M05bYwc5IU='
WHERE
key_id = '214d4c19116550aadd6e824d59da13f8b04daa31af6e00576b7d4dd9945dbee0'
AND (
token = 'qXgN5YxJlrD34whfPg+Jw0mRcysV+HwI/M05bYwc5IU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)