UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZASub1neZKogt+FBFZyRZBYpXDGMr6gw+SKc88mKfHg='
WHERE
key_id = 'd96d07a0148072b6e32e9f1753804ee19044f63225830c444ef7ac5f1096f40d'
AND (
token = 'ZASub1neZKogt+FBFZyRZBYpXDGMr6gw+SKc88mKfHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)