UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vO715Y8oY/Jw+wLttsg0CG2hr0KTpkcJpkxC82S/oho='
WHERE
key_id = 'd8909205a4b73664ff08aa59771a2fb0b7e389ffd401a2f5bf5d884f18bbc996'
AND (
token = 'vO715Y8oY/Jw+wLttsg0CG2hr0KTpkcJpkxC82S/oho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)