UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4XZsioSXYpGa1YchpQ6gLH2dmRDFjFaSO94MEt955dg='
WHERE
key_id = 'cf6ab852b3032426c878e1e536cf26ef874ce54a91e905ca4feed289e75ea74a'
AND (
token = '4XZsioSXYpGa1YchpQ6gLH2dmRDFjFaSO94MEt955dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)