UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5jVS7EPaWk8XifTdZl+EArzzTmXmWRhyspS8O/60ws='
WHERE
key_id = 'f8e0d1a0c91b694c590ce47a80c16c0bd0088921fd819e2cc2114262ee784cd9'
AND (
token = 'D5jVS7EPaWk8XifTdZl+EArzzTmXmWRhyspS8O/60ws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)