UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8tzceI5BXzOrZt3wyrU6N5CpLxc1x0HJVxtimQQtwJQ='
WHERE
key_id = '2ad1510faace8ef62b2c9b6df2a62ee12d9d25d73778fb591903b91182fe43ea'
AND (
token = '8tzceI5BXzOrZt3wyrU6N5CpLxc1x0HJVxtimQQtwJQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)