UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E7phIzJ75lbO35kCkz7Rjs0Aq7rE9/sG1Ai4zRWK1aI='
WHERE
key_id = 'c81dddf1490a70f0ea126978cb5c2f428c04663fa2df2566d17c3bafc6e19895'
AND (
token = 'E7phIzJ75lbO35kCkz7Rjs0Aq7rE9/sG1Ai4zRWK1aI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)