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