UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F7iMGC2C6bgVIo4GlO3NfMFVrMsHH/W9SophKGoClH4='
WHERE
key_id = '7de0f93956027b560bd6b8e0598772f5cb49e34c85d45a86d903109fed30692d'
AND (
token = 'F7iMGC2C6bgVIo4GlO3NfMFVrMsHH/W9SophKGoClH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)