UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lVmKY6gEDgjn7n+qk6Wc868Ie4ztBiyeuVRh76mItHg='
WHERE
key_id = 'f81f58dedc801974e501a4aa06bef144b85ed8bd25ce51fcb8dbf8d42379ab24'
AND (
token = 'lVmKY6gEDgjn7n+qk6Wc868Ie4ztBiyeuVRh76mItHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)