UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WzlBEHSm/Wb0J/dsVKfnP1ClpCgvseWFopF8NNkPKdM='
WHERE
key_id = 'ca434a42e00e7bf67ec6b41142fb248ad504f01d623dd9df50842e3e8df4317d'
AND (
token = 'WzlBEHSm/Wb0J/dsVKfnP1ClpCgvseWFopF8NNkPKdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)