UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wG2wnCHiNuuqyRC8Za46w3jzfETYP2mMEwokBG9GAPI='
WHERE
key_id = 'd209d7bfa96f1cd0785956eea22a66fc499bea2c62d81e81843bd9f9fdad9159'
AND (
token = 'wG2wnCHiNuuqyRC8Za46w3jzfETYP2mMEwokBG9GAPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)