UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCGthdtzAjDrGP+ieTGDpjJYSrLye+bwSBgag7tMbfc='
WHERE
key_id = '3e8e851d44ba6715f3b98d790c78c3e6b98331f3947e3cd38c2b96db285a1575'
AND (
token = 'zCGthdtzAjDrGP+ieTGDpjJYSrLye+bwSBgag7tMbfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)