UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GRpbmbe3VNmSnsM4BlyXqCGOpGRm6QCHr18Xl9XUS0='
WHERE
key_id = '02e0a127a2c775f566c4597e00e2b103a3cfb5da826783e8da97d7a83f93704c'
AND (
token = '1GRpbmbe3VNmSnsM4BlyXqCGOpGRm6QCHr18Xl9XUS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)