UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWQsiW5h2Z4s5KiRKU59ui6CF9BjAAfUQgVBnVZXHCg='
WHERE
key_id = 'c0d24a98192baedd4da1349ba0ddb3a80bbe35d225b032c4da048dd8b2d8fd70'
AND (
token = 'XWQsiW5h2Z4s5KiRKU59ui6CF9BjAAfUQgVBnVZXHCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)