UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zppfPjxpKz7kZZbegqdfFyRUm1qcSgCa/0ZydWU5Tao='
WHERE
key_id = 'e602ad6ad6c95a6613a62e3546ec8974a33827f2799bc38fa11e236ecba8f63b'
AND (
token = 'zppfPjxpKz7kZZbegqdfFyRUm1qcSgCa/0ZydWU5Tao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)