UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZBi2QIVSOomypVKwlvozosJtkMK4L+j1ixqgqQxlgU='
WHERE
key_id = 'e74506b4eae6314ea95e30dab4b16376045cfe88759ba39b50fb8ac308d6c2ea'
AND (
token = 'HZBi2QIVSOomypVKwlvozosJtkMK4L+j1ixqgqQxlgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)