UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HhpHB/DvMiXnp7QGaxPf2jm1On4ue6zSSdSF2r0h4Mo='
WHERE
key_id = 'e2b89eb97f350128f8b9a70ab36237a4ba0aaa490e062dfaa8593921c767559c'
AND (
token = 'HhpHB/DvMiXnp7QGaxPf2jm1On4ue6zSSdSF2r0h4Mo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)