UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UBUMbh9FCfYIL3QNddypn1ed8kXdNZ5C0cKe8wChY58='
WHERE
key_id = '7cc569900083ed5d612cfc01310278c7f8d095566ee4ddcca1bd6246afb2a7a0'
AND (
token = 'UBUMbh9FCfYIL3QNddypn1ed8kXdNZ5C0cKe8wChY58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)