UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zG8tONw7oeD5vVW0KHL7Kl/+Z1leySTQUEZs+s8vHZI='
WHERE
key_id = 'b42b3690455e682d8c9ef8e95879432cfb67f22d8222f40a5f219c48efc62808'
AND (
token = 'zG8tONw7oeD5vVW0KHL7Kl/+Z1leySTQUEZs+s8vHZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)