UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfL6zvg8L3JAbh5aUTVO17tgB0dkr6aI1gyY6QUYYzM='
WHERE
key_id = 'b926882c18e1c7894d1344977fb3b5d9caf8a88a025472ae237eb298b758d824'
AND (
token = 'XfL6zvg8L3JAbh5aUTVO17tgB0dkr6aI1gyY6QUYYzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)