UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UC4J2XNVp5UBX+Uikg+KJf9DrnxB3sFIcmVQy2N+44Q='
WHERE
key_id = '8e96c7e38b15d6b0948e32f5e9e80f13b3c37d67ec2911109f907c72783a2aee'
AND (
token = 'UC4J2XNVp5UBX+Uikg+KJf9DrnxB3sFIcmVQy2N+44Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)