UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtZpgPBE2x++xiXc5BCIx0QfYoHO0s2NFBBtwK8dsww='
WHERE
key_id = '82d657201690d24d0cec4df38c144a67ea6414f82f429fb7a4b642b917d4b2ba'
AND (
token = 'KtZpgPBE2x++xiXc5BCIx0QfYoHO0s2NFBBtwK8dsww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)