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