UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dJF2HlDx+u0hdbMBu5ezmb7ttb0Db9LBlGfBK2NAHA='
WHERE
key_id = '411e787d7c604cc31efd6233b68a5f6023a809aed28929601c3e1a2fcd0bbdad'
AND (
token = '9dJF2HlDx+u0hdbMBu5ezmb7ttb0Db9LBlGfBK2NAHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)