UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O+q0YUXjm+rZGHEk0yjQKM7S3SireqGGl8XuoJdoQXw='
WHERE
key_id = '4f6e05fe65f0a86278ce2aea633dc3402d2475cfe1184391266da3ed4008f4a6'
AND (
token = 'O+q0YUXjm+rZGHEk0yjQKM7S3SireqGGl8XuoJdoQXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)