UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '970MuHNsZR2tbyLJ8623+8Jldm9nfp6qY0GR6Nj4Ri8='
WHERE
key_id = 'bf6877a327173339d1188edf407517ac21b472cafffcd405421ed2d6a9bc3ba9'
AND (
token = '970MuHNsZR2tbyLJ8623+8Jldm9nfp6qY0GR6Nj4Ri8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)