UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNFzBhiIYdAn+aDfywj/kzISQE1BzCHWlmhil+rsrOI='
WHERE
key_id = '92988b8fc464900607f538e07b99cf6988834e863baae1faff859320d6cb09c1'
AND (
token = 'sNFzBhiIYdAn+aDfywj/kzISQE1BzCHWlmhil+rsrOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)