UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CMajzQsSYwJ5wB3gqkUEwTnYfybo531IafWqD+A3kcg='
WHERE
key_id = 'd5c532bd70918e30fae51a2bcf45aa4a3b02d374c374cbf74c8463b07d4b51dd'
AND (
token = 'CMajzQsSYwJ5wB3gqkUEwTnYfybo531IafWqD+A3kcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)